package onlyTest;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import java.io.File;
import java.io.IOException;

/**
 * JXL创建excel文件
 * Created by zzy on 2017/12/30.
 */
public class JxlExpExcel {

    public static void main(String[] args) {

        String[] title={"id","name","sex"};

        //创建文件
        File file=new File("e:/jxl_text.xls");
        try {
            file.createNewFile();
            //创建工作簿
            WritableWorkbook workbook= Workbook.createWorkbook(file);
            //创建sheet
            WritableSheet sheet=workbook.createSheet("sheet1",0);
            Label label=null;
            //第一行设置列明
            for (int i=0;i<title.length;i++){
                label=new Label(i,0,title[i]);
                sheet.addCell(label);
            }
            //追加数据
            for (int i=1;i<10;i++){
                label=new Label(0,i,"a"+1);
                sheet.addCell(label);
                label=new Label(1,i,"user"+1);
                sheet.addCell(label);
                label=new Label(2,i,"男");
                sheet.addCell(label);
            }
            //写入数据
              workbook.write();
              workbook.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }


}
